Pre-query Slicers can be used to set the slicer selections for specified slicers and parameters upon opening the tabulation, before the query is loaded. You can also create pre-query bookmarks to save multiple slicer selection combinations and apply them simultaneously.
Pre-query Slicers are available in Discover, Present, and Tabulate.
Note: this feature is not supported for SAP HANA or BW models containing predefined parameters.
Configuring Pre-Query Slicers
To create a pre-query slicer, open the slicer's Settings:
From the Other Settings tab, enable pre-query slicers:
Enable
Select the Enable checkbox to indicate that the query should not be run until the user specifies their slicer selections. The effect of this selection is that the Pre-Query slicer dialog opens and the user is prompted to select either bookmarks or individual selections for their discovery, publication, or tabulation slicers in the Pre-Query slicer dialog.
Note: The Pre-Query slicer dialog opens automatically when you open the discovery, presentation, or tabulation in its app, the discovery in the Viewer, or the presentation at runtime. If you view the discovery or presentation in the Hub or as an Embedded visual, you will need to click the Make Pre-Selections option to open the Pre-query slicer dialog.
Apply default load mode
Use the Apply default load mode checkbox to indicate which options should be selected in the Pre-query slicer dialog by default:
- Select the checkbox to use the default slicer selection.
- Clear the checkbox to use the last selected slicer in the Pre-query slicer dialog.
Select Pre-Query Slicers
When you open a tabulation that contains pre-query slicers, you are presented with the Pre-query Slicer dialog (image below). The dialog presents all pre-query slicers in the report; each slicer can be searched and enabled or disabled as needed.
- To load the query, you must first select the required slicer values (purple highlight below).
- Save your slicer selections as bookmarks (yellow highlight below) so that you can quickly select 1 or more slicer values at once.
- To revert to the default slicer selection, click Restore Defaults (green highlight below).
Pre-Query Slicers from Multiple Sources
If your tabulation contains pre-query slicers from multiple sources, they will be arranged by data model, as in the image below.
Navigate the list of data models (yellow highlight below) to expose the slicers; be sure to make slicer selections for all slicers, or disable any slicers you don't want to affect the query.
Pre-Query Bookmarks
Bookmarks allow you to save multiple pre-query slicer selections (purple highlight above). You can then select the required bookmark to load multiple slicer selections into the query, rather than manually changing each of the slicers.
You can save multiple pre-query bookmarks pointing to different combinations of slicer selections. Bookmarks are not shareable and will only be seen by the current user.
Pre-query bookmarks are similar in concept to Presentation Bookmarks. However, they are only available for pre-query slicers, from the pre-query slicer dialog.
To create a pre-query slicer bookmark:
- Make the required slicer selections from the Pre-query Slicers dialog.
- Click the plus sign + next to the Bookmarks field; the slicer selections will be added to a drop-down list.
- Next time you open the Pre-query Slicers dialog, your bookmark will appear in the Bookmarks drop-down list. Select the required bookmark and click "Apply" to load the query.
To edit or delete a bookmark, select it from the list and click the edit icon.
- Click here to learn how to manage bookmarks.
Note: Pre-query slicer bookmarks are saved only to the current report for the current user.
Manage Pre-Query Slicers
When pre-query slicers are enabled in the query, the Pre-query Slicer button will appear in the Advanced Settings tab (purple highlight below):
Click this button to open the Pre-query Slicer dialog (as shown above), where you can add, edit, and delete pre-query slicer bookmarks.